TEXT Datei importieren Google Tabellen wird nicht richtig dargestellt

MrMultimarHD · 21. September 2023

Guten Tag,

ich habe eine Datei als txt welche als in google Tabellen als CSV importiert werden soll.
In der Datei sind alle Werte durch ein Komma getrennt.

Wie das importieren an sich funktioniert weiß ich, allerdings übernimmt er einfach keine Trennung in Form einer Tabelle.
Natürlich habe ich auch eingestellt, dass die Kommas als Trennwert erkannt werden sollen.
(anbei mal ein Bild davon)

Eigentlich müsste er doch jedem Wert ganz normal eine Zelle zuordnen oder nicht?
Habe da auch schon Videos etc. angeschaut in jedem Video erkennt das Programm direkt die Zuordnung und stellt alles schön tabellarisch da.

Freue mich auf antworten.
Danke und Grüße

kartoffelpü · 21. September 2023

Klappt hier:

Stell doch mal deine Textdatei zur Verfügung, vielleicht ist da ja irgendein Fehler drin.

Ponderosa · 21. September 2023

In LibreOffice kann man bei Textimport an verschiedenen Positionen, wie Komma, Semikolon etc., Einstellungen vornehmen.

Such mal ähnliche Einstellungen bei Google Tabellen.

MrMultimarHD · 22. September 2023

Hallo,

danke für die schnellen antworten.

Datei sieht so aus:

"Requested_prod_id","Requested_GTIN(EAN/UPC)","Requested_Icecat_id","ErrorMessage","Supplier","Prod_id","Icecat_id","GTIN(EAN/UPC)","Category","CatId","ProductFamily","ProductSeries","Model","Updated","Quality","On_Market","Product_Views","HighPic","HighPic Resolution","LowPic","Pic500x500","ThumbPic","Folder_PDF","Folder_Manual_PDF","ProductTitle","ShortDesc","ShortSummaryDescription","LongSummaryDescription","LongDesc","ProductGallery","ProductGallery Resolution","ProductGallery ExpirationDate","360","EU Energy Label","EU Product Fiche","PDF","Video/mp4","Other Multimedia","ProductMultimediaObject ExpirationDate","ReasonsToBuy","Spec 1","Spec 2","Spec 3","Spec 4","Spec 5","Spec 6","Spec 7","Spec 8","Spec 9","Spec 10","Spec 11","Spec 12","Spec 13","Spec 14","Spec 15","Spec 16","Spec 17","Spec 18","Spec 19","Spec 20","Spec 21","Spec 22","Spec 23","Spec 24","Spec 25","Spec 26","Spec 27","Spec 28","Spec 29","Spec 30","Spec 31","Spec 32","Spec 33","Spec 34","Spec 35","Spec 36","Spec 37","Spec 38","Spec 39","Spec 40","Spec 41","Spec 42"
"","","110259174","","Gigabyte","GV-N4070AORUS M-12GD","110259174","4719331312954","Grafikkarten","170","AORUS","","AORUS GeForce RTX 4070 MASTER 12G","20230511145136","ICECAT","1","9732","http://images.icecat.biz/img/gallery/56cb82e2f5fa5f1f3919c9f8a9b8d4a5.jpg","1000x1000","http://images.icecat.biz/img/gallery_lows/56cb82e2f5fa5f1f3919c9f8a9b8d4a5.jpg","http://images.icecat.biz/img/gallery_mediums/56cb82e2f5fa5f1f3919c9f8a9b8d4a5.jpg","http://images.icecat.biz/img/gallery_thumbs/56cb82e2f5fa5f1f3919c9f8a9b8d4a5.jpg","","","Gigabyte AORUS GeForce RTX 4070 MASTER 12G NVIDIA 12 GB GDDR6X","","Gigabyte AORUS GeForce RTX 4070 MASTER 12G, GeForce RTX 4070, 12 GB, GDDR6X, 192 Bit, 7680 x 4320 Pixel, PCI Express 4.0","Gigabyte AORUS GeForce RTX 4070 MASTER 12G. Grafikprozessorenfamilie: NVIDIA, GPU: GeForce RTX 4070, Prozessortaktfrequenz: 2595 MHz. Separater Grafik-Adapterspeicher: 12 GB, Grafikkartenspeichertyp: GDDR6X, Breite der Speicherschnittstelle: 192 Bit. Maximale Auflösung: 7680 x 4320 Pixel. DirectX-Version: 12 Ultimate, OpenGL-Version: 4.6. Schnittstelle: PCI Express 4.0. Kühlung: Aktiv, Anzahl Lüfter: 3 Lüfter","","http://images.icecat.biz/img/galler.../gallery/9213257a396703b02da5009cc7e2ebc4.jpg","1000x1000|1000x1000|1000x1000|1000x1000|1000x1000|1000x1000|1000x1000|1000x1000|1000x1000","||||||||","","","","","","","","","Prozessor","Grafikprozessorenfamilie: NVIDIA","GPU: GeForce RTX 4070","Maximale Auflösung: 7680 x 4320 Pixel","CUDA: Ja","Prozessortaktfrequenz: 2595 MHz","CUDA-Kerne: 5888","Prozessor-Boost-Taktfrequenz: 2475 MHz","Maximale Displays pro Videokarte: 4","Speicher","Separater Grafik-Adapterspeicher: 12 GB","Grafikkartenspeichertyp: GDDR6X","Breite der Speicherschnittstelle: 192 Bit","Speicherbandbreite (max.): 21 GB/s","Anschlüsse und Schnittstellen","Schnittstelle: PCI Express 4.0","Anzahl HDMI-Anschlüsse: 1","Anzahl DisplayPort Anschlüsse: 3","HDMI-Version: 2.1a","DisplayPorts-Version: 1.4a","Leistungen","TV Tuner integriert: Nein","DirectX-Version: 12 Ultimate","OpenGL-Version: 4.6","Dual-Link-DVI: Nein","NVIDIA G-SYNC: Ja","Design","Kühlung: Aktiv","Kühltechnik: GIGABYTE WINDFORCE 3X","Anzahl Lüfter: 3 Lüfter","Formfaktor: Full-Height/Full-Length (FH/FL)","Beleuchtung: Ja","Produktfarbe: Schwarz","Leistung","Min. Systemstromversogung: 700 W","Zusätzliche Stromanschlüsse: 1x 16-pin","Gewicht und Abmessungen","Tiefe: 342 mm","Höhe: 70,6 mm","Breite: 153 mm","Verpackungsdaten","Verpackungsart: Box"

N00bn00b · 22. September 2023

Hat problemlos geklappt:

Selektierte Daten in A1 einfügen:

Daten > Text in Spalten aufteilen, Trennzeichen "Automatisch erkennen":

Ist nur eine Header- und eine Datenzeile.

kartoffelpü · 22. September 2023

Eigentlich hatte ich um die Datei und nicht den Inhalt gebeten.

Eventuell wurde deine Textdatei in einem Format gespeichert, womit Sheets nicht richtig klar kommt.
Wenn ich den Inhalt in eine Textdatei mit UTF-8 Encoding und CR LF am Ende speichere, klappt der Import zumindest ohne Probleme.

MrMultimarHD · 23. September 2023

Datei gibt es in dem Sinne nicht, mir wurde vom Dienstleister nur dieser Text Strip ausgegeben.

Habe mir es eben dann als txt. Datei gespeichert.

Leider finde ich unter Daten nicht die Option "Nur Werte einfügen."

@N00bn00b

N00bn00b · 23. September 2023

Sorry, das gibt es dort tatsächlich nicht. Einfach den Text selektieren, und dann in A1 pasten, habs in meinem Beitrag geändert.

MrMultimarHD · 23. September 2023

Nein also das funktioniert bei mir nicht.
Hatte es vorhin hinbekommen, also alles gut.

Jetzt habe ich aber folgenden Skript der sich nicht Ordnen lässt, obwohl ich als Trennzeichen "Komma" angegeben habe.

Könnt euch das ja falls ihr wollt mal anschauen:

nummer,bezeichnung,kategoriebez,eancode,hersteller_nr,herstellerbez,vk_preis,bestand,im_zulauf
39830,"Adapter DeLock DP male - DVI female","Adapter","4043619618477","61847","Delock",8.60,"1",""
29076,"Adapter DeLock DP zu VGA","Adapter","4043619618484","61848","Delock",12.60,"7",""
71711,"APC Back-UPS USV BX750MI Wechselstrom 230 V","Adapter","0731304410799","BX750MI","APC",80.40,"9",""
47256,"APC Back - UPS ES400VA BE400-GR 230V","Adapter","731304233367","BE400-GR","APC",78.90,"3",""
47152,"APC Back - UPS Pro 1500 BR1500G-GR - USV - Wechselstrom 230 V","Adapter","0731304286875","BR1500G-GR","APC",338.90,"0","12.09.2023"
50100,"APC Back UPS 650 BK650EI - USV - Wechselstrom 230 V","Adapter","0731304219781","BK650EI","APC",131.40,"13",""
57894,"APC Back -UPS USV BE650G2-GR Wechselstrom 230V","Adapter","0731304347217","BE650G2-GR","APC",82.40,"0",""
51621,"APC Back-UPS BR1300MI - USV - Wechselstrom 230 V","Adapter","0731304346906","BR1300MI","APC",264.30,"0","12.09.2023"
67049,"APC Back-UPS BR900MI - USV- Wechselstrom 230 V","Adapter","0731304346944","BR900MI","APC",191.90,"0","13.09.2023"
66788,"APC Back-UPS BX1200MI Wechselstrom 230 V","Adapter","0731304410812","BX1200MI","APC",121.40,"2",""
48828,"APC Back-UPS BX500CI - USV - Wechselstrom 230 V","Adapter","0731304307365","BX500CI","APC",59.60,"0",""
70279,"APC Back-UPS BX950MI-GR - USV - Wechselstrom 230 V","Adapter","0731304410850","BX950MI-GR","APC",105.90,"20",""
47143,"APC Back-UPS Pro 900 - USV BR900G-GR - Wechselstrom 230 V","Adapter","0731304286912","BR900G-GR","APC",204.90,"0","12.09.2023"
76650,"APC Back-UPS Pro BR1200SI USV Wechselstrom 220-240 V BR1200","Adapter","0731304346890","BR1200","APC",319.90,"10",""
70275,"APC Back-UPS Pro BR1600MI Wechselstrom 230 V","Adapter","0731304346913","BR1600MI","APC",335.20,"0","12.09.2023"
58288,"APC Back-UPS Pro USV BR650MI - USV - Wechselstrom 230 V","Adapter","0731304346937","br650MI","APC",137.00,"34",""
56519,"APC Back-UPS USV BE850G2-GR Wechselstrom 230V","Adapter","0731304347286","BE850G2-GR","APC",100.60,"20",""
58910,"APC Back-UPS USV BX750MI-GR Wechselstrom 230 V","Adapter","0731304410843","BX750MI-GR","APC",90.90,"26",""
72502,"APC Easy UPS BV1000I-GR - USV - Wechselstrom 230 V","Adapter","0731304338246","BV1000I-GR","APC",86.40,"5",""
58493,"APC Easy UPS BV500I - USV- Wechselstrom 230 V","Adapter","0731304338260","BV500I","APC",54.90,"1",""
72500,"APC Easy UPS BV500I-GR - USV - Wechselstrom 230 V","Adapter","0731304338284","BV500I-GR","APC",58.60,"7",""
51617,"APC Easy UPS BV650I - USV- Wechselstrom 230 V","Adapter","0731304338307","BV650I","APC",31.90,"49",""
51619,"APC Easy UPS BV800I - USV- Wechelstrom 230 V","Adapter","0731304338345","BV800I","APC",75.40,"3",""
72498,"APC Easy UPS BVX1200LI-GR - USV-Wechselstrom 230 V","Adapter","0731304404606","BVX1200LI-GR","APC",99.90,"10",""
58911,"APC Easy UPS BVX700LI - USV- Wechselstrom 230 V","Adapter","0731304404484","BVX700LI","APC",68.90,"0",""
59960,"APC Easy UPS BVX700LI-GR - USV - Wechselstrom 230 V","Adapter","0731304404583","BVX700LI-GR","APC",65.90,"1",""
61156,"APC Easy UPS BVX900LI-GR - USV - Wechselstrom 220-240 V","Adapter","0731304404590","BVX900LI-GR","APC",84.50,"7",""
76235,"APC Easy UPS Online APV9601","Adapter","0731304345008","APV9601","APC",155.90,"6",""
52887,"APC Performance SurgeArrest PL8VT3, Überspannungsschutz","Adapter","0731304281399","PL8VT3-DE","APC",31.90,"39",""
49392,"APC Smart-UPS SC450RMI1U - USV (Rack-einbaufähig)","Adapter","0731304222712","SC450RMI1U","APC",256.90,"0",""
32763,"APC Smart-UPS SMT1500 LCD - USV Wechselstrom 230V","Adapter","0731304268680","SMT1500I","APC",440.90,"0",""
48981,"APC Smart-UPS SMT750IC - USV - Wechselstrom 220/230/240 V","Adapter","0731304340317","SMT750IC","APC",303.90,"0",""
50857,"APC Smart-UPS SMT750RMI2UC - USV (Rack-einbaufähig)","Adapter","0731304340324","SMT750RMI2UC","APC",458.90,"1",""
47740,"APC SurgeArrest + Battery Backup 325VA - BE325-GR","Adapter","0731304211143","BE325-GR","APC",78.50,"5",""
76853,"APC SurgeArrest Essential PL5B Überspannungsschutz PL5B-DE","Adapter","0731304281368","PL5B-DE","APC",26.90,"46",""
48826,"APC SurgeArrest Essential, Überspannungsschutz PM5-GR","Adapter","0731304313120","PM5-GR","APC",15.40,"21",""
48832,"APC SurgeArrest Essential, Überspannungsschutz PM8-GR","Adapter","0731304313144","PM8-GR","APC",28.90,"13",""
51616,"APC SurgeArrest Essential,Überspannungsschutz PM6U-GR","Adapter","0731304313724","PM6U-GR","APC",29.40,"19",""
73331,"Asus Netzwerkadapter USB-BT500 USB 2.0 Bluetooth","Adapter","4718017476799","90IG05J0-MO0R00","ASUS",11.00,"100",""
76553,"Delock Netzwerkadapter PCIe 2.0x8 - 88505","Adapter","4043619885053","88505","Delock",123.30,"1",""
21965,"D-Link Hub DUB-H4/E","Adapter","0790069243905","DUB-H4/E","D-Link",13.40,"0","15.09.2023"
72671,"HP USB-C Travel Hub G2 Dockin Station 235N8AA#ABB","Adapter","0195122815479","235N8AA#ABB","HP",37.90,"14",""
33545,"I-Tec USB 3.0 Dual Docking Station U3HDMIDVIDOCK","Adapter","8595611700620","U3HDMIDVIDOCK","I-Tec",73.90,"3",""
72131,"i-tec USB 3.0/USB-C Docking Station U3DUALHDMIDOCK","Adapter","8595611703843","U3DUALHDMIDOCK","I-Tec",77.20,"46",""
68967,"i-tec USB-C Docking Station CAHDMIDVIDOCKPRO DVI/HDMI,GigE","Adapter","8595611704079","CAHDMIDVIDOCKPRO","I-Tec",56.50,"7",""
72321,"I-TEC USB-C Dual Display Docking Station with Power Delivery and Universal Charger C31DUALDPDOCKPD100W","Adapter","8595611703799","C31DUALDPDOCKPD100W","I-Tec",89.50,"9",""
74577,"i-tec USB-C Metal Nano Dock C31NANODOCKPD 4K HDMI + Power Delivery","Adapter","8595611702891","C31NANODOCKPD","I-Tec",28.90,"22",""
69615,"Lenovo Thinkpad Docking Station 40AJ0135EU,VGA,HDMI,2xDisplayPort","Adapter","0192076019854","40AJ0135EU","Lenovo",31.90,"1",""
72112,"LevelOne WUA-1810E Netzwerkadapter USB 3.0","Adapter","4015867202043","WUA-1810E","LevelOne",14.40,"0",""
47000,"LogiLink 2-Port Gigabit LAN PCI-Express Karte PC0075","Adapter","4052792030600","PC0075","LogiLink",29.90,"0","13.09.2023"
76639,"LogiLink Adapter Fast Ethernet USB 2.0 to RJ45 UA0025C","Adapter","4260113566596","UA0025C","LogiLink",7.20,"9",""
76636,"LogiLink Bluetooth 4.0-Adapter, USB 2.0, USB-A BT0037","Adapter","4052792037470","BT0037","LogiLink",6.40,"3",""
76637,"LogiLink Bluetooth 5.0-Adapter, USB 2.0, USB-A BT0058","Adapter","4052792063530","BT0058","LogiLink",4.70,"21",""
77211,"LogiLink Gigabit PCI Express Netzwerkkarte PC0029A","Adapter","4260113564745","PC0029A","LogiLink",0.00,"0","13.09.2023"
77139,"LogiLink HDMI-Adapter A/F zu DVI-D/M 1080p AH0001","Adapter","4260113560075","AH0001","LogiLink",1.40,"0","11.09.2023"
20891,"LogiLink PCI Express Karte 2x Seriell PC0031","Adapter","4260113563915","PC0031","LogiLink",14.42,"0","13.09.2023"
76183,"Logilink Professional Microphone Boom Arm Stand black AA0127","Adapter","4052792054781","AA0127","LogiLink",27.90,"7",""
76640,"LogiLink Sehr flacher USB 3.2 Gen 1x1 USB-C, 3-Port Hub & Kartenleser UA0312","Adapter","4052792048674","UA0312","LogiLink",14.30,"7",""
76245,"LogiLink Steckdosendapter 1 x USB - PA0217","Adapter","4052792057027","PA0217","LogiLink",3.40,"23",""
76251,"LogiLink Steckdosenleiste 3-fach - LPS229","Adapter","4052792049534","LPS229","LogiLink",2.50,"19",""
76253,"LogiLink Steckdosenleiste 6-fach + 7 Schalter - LPS233","Adapter","4052792049572","LPS233","LogiLink",10.90,"13",""
77137,"LogiLink Universelle Halterung für Media Player BP0049","Adapter","4052792046540","BP0049","LogiLink",3.40,"0","29.09.2023"
76250,"LogiLink USB 2.0 Adapter USB-A/M zu DB9 (RS232)/M AU0034","Adapter","4052792014884","AU0034","LogiLink",9.50,"15",""
76254,"LogiLink USB 2.0 Hub 4-port mit Netzteil - UA0085","Adapter","4052792004410","UA0085","LogiLink",8.20,"7",""
76179,"Logilink USB 2.0 Hub 7 port incl. Power Supply UA0148","Adapter","4052792000924","UA0148","LogiLink",15.90,"9",""
76178,"Logilink USB 3.0 Hub 7+1 port incl. Power Supply UA0228","Adapter","4052792033694","UA0228","LogiLink",24.30,"22",""
76252,"LogiLink USB 3.0-Hub mit AIO-Kartenleser - CR0042","Adapter","4052792048698","CR0042","LogiLink",16.90,"5",""
76643,"LogiLink USB 3.2 Gen 1x1 USB-C 3-Port Hub, mit Kartenleser UA0305","Adapter","4052792048568","UA0305","LogiLink",10.40,"7",""
76866,"LogiLink USB 3.2 Gen1 Type-C Adapter C/M zu USB-A/F OTG 0,15 m CU0106","Adapter","4052792070774","CU0106","LogiLink",2.10,"10",""
76149,"Logilink USB Travel Charger black PA0187","Adapter","4052792051445","PA0187","LogiLink",3.09,"30",""
76150,"Logilink USB Travel Charger USB-AF &USB-CF PA0301","Adapter","4052792069709","PA0301","LogiLink",13.20,"10",""
76151,"Logilink USB Travel Charger USB-CF PA0302","Adapter","4052792069723","PA0302","LogiLink",18.40,"10",""
76968,"LogiLink Wi-Fi Smart Steckdosenleiste 6-fach (CEE7/3) 4x USB Tuya kompatibel SH0105","Adapter","4052792066784","SH0105","LogiLink",44.90,"10",""
39012,"TP-Link Hub UH400 4-port","Adapter","6935364091477","UH400","TP-Link",8.70,"69",""
74935,"TP-Link Hub UH700","Adapter","6935364010065","UH700","TP-Link",22.10,"32",""
39015,"TP-Link Hub UH720","Adapter","6935364010041","UH720","TP-Link",25.90,"93",""
40339,"TP-Link Netzwerkadapter Archer T2U","Adapter","6935364089917","Archer T2U","TP-Link",12.90,"38",""
59973,"TP-Link Netzwerkadapter Archer T2U Nano USB 2.0","Adapter","6935364099978","Archer T2U Nano","TP-Link",9.60,"0","15.09.2023"
50959,"TP-Link Netzwerkadapter Archer T3U","Adapter","6935364083830","ARCHER T3U","TP-Link",13.90,"83",""
76139,"TP-Link Netzwerkadapter Archer T3U Nano","Adapter","6935364072667","ARCHER T3U NANO","TP-Link",15.20,"27",""
60270,"TP-Link Netzwerkadapter Archer T3U Plus USB 3.0","Adapter","6935364053413","Archer T3U Plus","TP-Link",13.90,"2",""
70105,"TP-Link Netzwerkadapter Archer T5E","Adapter","6935364088965","ARCHER T5E","TP-Link",25.40,"0","27.09.2023"
74725,"TP-Link Netzwerkadapter Archer TX20U plus V1","Adapter","4897098687888","ARCHER-TX20UPLUS","TP-Link",28.90,"12",""
74143,"TP-Link Netzwerkadapter Archer TX50E","Adapter","6935364052867","ARCHER TX50E","TP-Link",39.90,"0",""
74934,"TP-Link Netzwerkadapter PCIe 3.0 TX401","Adapter","6935364072827","TX401","TP-Link",70.90,"4",""
74918,"TP-Link Netzwerkadapter PCIe Archer TX3000E","Adapter","6935364088897","TX3000E","TP-Link",39.90,"22",""
72115,"TP-Link Netzwerkadapter UB500 USB 2.0 Bluetooth 5.0","Adapter","4897098683446","UB500","TP-Link",8.30,"0",""
74933,"TP-link Smart Stecker Tapo P100","Adapter","4897098681619","Tapo P100","TP-Link",8.90,"5",""
74012,"TP-Link Smart-Stecker Tapo P115 - kabellos","Adapter","4897098687406","TAPO P115","TP-Link",13.50,"20",""
76138,"TP-Link Tapo H100 Smart Hub mit Signalton","Adapter","4897098687192","TAPO H100","TP-Link",16.60,"10",""
34892,"TP-Link USB Adapter SuperSpeed USB 3.0 UE300","Adapter","6935364091743","UE300","TP-Link",11.50,"56",""
52326,"UbiQuiti CKG2-RM Netzwerk-Einrichtung, Rack montierbar 48,30cm (19)(1 Jahr Garantie","Adapter","0817882025607","CKG2-RM","UbiQuiti",78.60,"10",""
70858,"UbiQuiti Smart FloodLight (1 Jahr Garantie)","Adapter","0810010075093","UP-Floodlight","UbiQuiti",90.40,"0",""
49984,"UbiQuiti Unifi Cloud Key UCK-G2-PLUS Fernsteuerungsgerät(1 Jahr Garantie)","Adapter","0817882024532","UCK-G2-PLUS","UbiQuiti",167.60,"1",""
63256,"USB Hub Logilink 3.2 Gen 1x1 USB-C, 4-Port (UA0311)","Adapter","4052792048667","UA0311","LogiLink",10.50,"17",""
47794,"Batterie Varta Lithium - Knopfzelle CR2025 Einzelpack","Batterien, lithium, Knopfzelle","4008496276875","06025101401","Panasonic",0.40,"0",""
53743,"Batterie Varta Lithium - Knopfzelle CR2430 Einzelpack","Batterien, lithium, Knopfzelle","4008496276929","06430101401","Panasonic",0.95,"16",""
44531,"Cooler Be Quiet Dark Rock 4","Cooler","4260052186251","BK021","be quiet!",56.47,"53",""
44530,"Cooler Be Quiet Dark Rock Pro 4","Cooler","4260052186268","BK022","be quiet!",69.81,"40",""
49295,"Cooler Be Quiet Dark Rock Pro TR4","Cooler","4260052186985","BK023","be quiet!",67.59,"0",""
50379,"Cooler Be Quiet Dark Rock Slim","Cooler","4260052187319","BK024","be quiet!",46.37,"35",""
68961,"Cooler Be Quiet Dark Rock TF 2","Cooler","4260052188705","BK031","be quiet!",71.43,"8",""
61637,"Cooler Be Quiet MC1","Cooler","4260052188514","BZ002","be quiet!",8.19,"47",""
61638,"Cooler Be Quiet MC1 Pro","Cooler","4260052188521","BZ003","be quiet!",10.61,"80",""
57412,"Cooler Be Quiet Pure Loop 120mm ALL-in-One

N00bn00b · 23. September 2023

Auch das ging problemlos:

Wichtig: Nach dem pasten die ganze Spalte A markieren:

Dann wieder "Text in Spalten aufteilen":

MrMultimarHD · 25. September 2023

Hallo Leute,

dank euch komme ich jetzt mit dem Kram klar!

Danke dafür.

Nun stehe ich vor der Herausforderung zwei CSV Dateien zusammenführen zu müssen.
In einer Datei sind EAN, Titel, ID, Preis enthalten
In der anderen ebenfalls EAN, Titel, Bilder, Produktbeschreibung usw.

Diese daten müssten der EAN zugeordnet werden, also das z.B die Bilder (die ja einer EAN zugeordnet sind) dann eben in der anderen der Datei genau dieser EAN und dem Preis der zu dieser EAN gehört zugeordnet wird.

Wisst ihr, was ich meine?
Müsste gehen oder?

Ich danke euch!
LG

N00bn00b · 25. September 2023

Das geht via SVERWEIS über die EAN, letztere sollte eindeutig sein.

MrMultimarHD · 25. September 2023

Alles klar, werde ich mir mal anschauen

Danke

MrMultimarHD · 29. September 2023

Hallo Leute, ich habe mal versucht mich da einzuarbeiten und muss gestehen, dass ich da gar nicht durchblicke.

Habe nun auf Fiverr mal nach Leuten geschaut, die mir da eventuell helfen können. Auch das gestaltet sich schwierig.

Gibt es hier jemanden, der für etwas Geld bereit wäre, mir die zwei Dateien zusammenzuführen?

Wäre wohl für jemanden, der sich auskennt, ein simpler Job

Danke!

cumulonimbus8 · 29. September 2023

Sagen wir: ich nehme kein Geld - und weit mehr nehme ich nicht diese «Google-Spielzeuge».

In letzter Zeit komme immer mehr Fragen zu Google-Anwendungen bei denen ich nur staune was da alles klemmt und hapert. Ist halt Nulltarif für den Einfachanwender mit einfachen Ansprüchen, und so benimmt es sich. MSO oder halt LO.

CN8

N00bn00b · 30. September 2023

Naja, da klemmt ja eigentlich noch gar nix - man muss nur die beiden Tabellen/Worksheets via SVERWEIS verbinden, das schafft auch Google Calc. Es gibt ja tatsächlich Einfachanwender mit einfachen Ansprüchen, da kann es durchaus Sinn machen, das mal so zu testen. Wenn die Ansprüche wachsen, kann man sich anderen "Spielzeugen" wie Excel oder dann Richtung DB bewegen.

RPP63 · 30. September 2023

@cumulonimbus8
Nur meine Meinung:
Google Sheets ist beileibe kein Spielzeug für "einfache" Anwender mehr!
Es beherrscht sämtliche Arraymanipulationen von Excel, tlw. sogar besser (s.g. spillende Formeln).
[besser ist z.B. SORTN(), welches umfangreichere Sortieroptionen als Excels SORTIERENNACH() bietet]
Außerdem Variablendeklaration auf Formelbasis mittels LET()
Davon ist LibreCalc noch weit entfernt!

Off topic:
Weil Du gerade Spielereien ansprichst:
Gib mal in Google Sheets in A1 ein beliebiges Jahr ein.
In A2:

Code:

=ARRAYFORMULA(LET(Monate;TEXT(DATE(;SEQUENCE(1;12);17);"mmmm");
m;SEQUENCE(1;12);j;DATE(A1;m;SEQUENCE(31));
Rest;IF(MONTH(j)=m;j;"");{Monate;Rest}))

Enter und staunen …

cumulonimbus8 · 30. September 2023

Wenn ich worüber staune dann am ehesten wie weit eine Tabellenkalkulation mal wieder eine Datenbank abgeben soll.

Wäre das alles so einfach müsste man nicht so Einfachem hier fragen…

Google baut einfach nach - aber «viel» muss lange nicht «brauchbar» heißen.

CN8

TEXT Datei importieren Google Tabellen wird nicht richtig dargestellt

Ensign

Anhänge

Rear Admiral

Commander

Ensign

Lt. Junior Grade

Rear Admiral

Ensign

@N00bn00b​

Anhänge

Lt. Junior Grade

Ensign

Lt. Junior Grade

Ensign

Lt. Junior Grade

Ensign

Ensign

Fleet Admiral

Lt. Junior Grade

Cadet 4th Year

Fleet Admiral

Ähnliche Themen

@N00bn00b