14,970
edits
Export MySQL query to Excel file: Difference between revisions
Jump to navigation
Jump to search
m
→Technical issues: If it costs too much time to convert to Excel file
No edit summary |
|||
| Line 11: | Line 11: | ||
== Technical issues: If it costs too much time to convert to Excel file == | == Technical issues: If it costs too much time to convert to Excel file == | ||
The important steps before generating CSV file. | The important steps before generating CSV file. These steps reduce the problems when the CSV file was converted to Excel file. | ||
* Add '''delimiter character''' between different column ex: comma symbol (,) or tab symbol | * Add '''delimiter character''' between different column ex: comma symbol (,) or tab symbol | ||
* Add '''enclosure character''' ex: double quote symbol (") or single quote symbol (') | * Add '''enclosure character''' ex: double quote symbol (") or single quote symbol (') | ||