How to transfer the output of an SQLite query into a spreadsheet (Excel)
(1.1) By Techcosec Limited (DigitalSplendid) on 2022-05-19 10:15:34 edited from 1.0 [source]
After running the query, I am getting 4 rows of output. How to transfer the same into an Excel file. I know I can do this manually, but there should be a method. https://www.canva.com/design/DAFBHXuOJ3s/jCG3GYmGdx4UfwZ0bJHO9A/view?utm_content=DAFBHXuOJ3s&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton
(2) By Warren Young (wyoung) on 2022-05-19 05:51:25 in reply to 1.0 [link] [source]
(3) By Simon Slavin (slavin) on 2022-05-19 05:53:25 in reply to 1.0 [link] [source]
If you want to ask a question here, please ask the question here. Don't post a link to some other place.
Write the result of the query to a .csv file and import the .csv file into Excel.
(5) By Techcosec Limited (DigitalSplendid) on 2022-05-19 10:17:35 in reply to 3 [link] [source]
Still trying to understand how to paste an image (so that I need not attach link).
(6) By Stephan Beal (stephan) on 2022-05-19 10:40:29 in reply to 5 [link] [source]
Still trying to understand how to paste an image (so that I need not attach link).
This forum software does not support attachments on posts.
(7) By Richard Hipp (drh) on 2022-05-19 10:46:54 in reply to 5 [link] [source]
Use your words.
This forum is a public record that will be maintained for the next 28 years. We deliberately do not allow you to post huge image files, as we don't what to have to store those images for 28 years.
(8.2) By AlexJ (CompuRoot) on 2022-05-19 14:38:22 edited from 8.1 in reply to 5 [link] [source]
Deleted(4) By Aask (AAsk1902) on 2022-05-19 06:16:13 in reply to 1.0 [link] [source]
The following will start a new Excel instance and send the output of your SQL statement (second line below) to a worksheet.
sqlite> .once -x
sqlite> select * from employees;
Then, you can decide whether you want to save (or discard) the results using the Excel user interface.