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
| 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 | The important steps before generating CSV file. The CSV file will be converted to Excel file more convenient. | ||
* 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 (') | ||