When using Import File Data, common questions usually involve file formats, garbled CSV text, long import times, and data refresh behavior; this FAQ covers 4 common questions.
FAQ
What should I do if I see a file format not supported message?
- Confirm that the file is in a supported format: XLSX, XLS, ET, CSV, Smart Spreadsheet, or Multi-dimensional Table.
- If the file uses another format, save it again in a supported format first.
- Run the Import File Data workflow again and select the file one more time.
Why does my CSV file show garbled text after import?
- Check whether the original CSV file uses an encoding that matches the file content.
- Save the file again in a more common encoding such as UTF-8.
- Import the file again and verify whether text, symbols, and numbers display correctly.
What should I do if the import takes too long?
- Check whether the source file is large or contains many worksheet contents.
- If you are importing from online documents, confirm that your internet connection is stable.
- Also check whether your cloud storage has enough remaining space, and then try again.
Can imported data update automatically later?
- Data imported through this workflow is usually a static result.
- If the original file changes, run the import again to bring in the updated content.
- If you need scheduled synchronization, use a workflow that is designed for ongoing sync.
Glossary
| Term | Definition |
|---|---|
| Smart Spreadsheet | The WPS spreadsheet workspace for structured data, where imported results can be placed into worksheets. |
| Online documents | Files stored in cloud-based paths that can be selected directly during import. |
| CSV | A common plain-text table exchange format that uses separators to organize fields. |
| Worksheet | A single sheet area inside a spreadsheet file. After import, WPS creates new worksheets to hold the result. |